ALTER USER user_name WITH PASSWORD 'new_password';
sudo -u postgres psql postgres
\password postgres
postgres=# ALTER USER postgres PASSWORD 'myPassword'; ALTER ROLE